<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.sql.*"%>
<%
    try{
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:DERMDDB", "der_stores", "derstores");
    Statement stmt = conn.createStatement();               
    String sql="select count(id) as count from v_der_stores";
    ResultSet rs=stmt.executeQuery(sql);
    while(rs.next()) {
%>
<%=rs.getString("count")%>
<% 
}
    rs.close();
    stmt.close();
    conn.close();
    }
catch (Exception e){
        out.print(e);
}
%>